UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHROK+tZX7AyFQSZ8iUGeO0ZmWonAqEPB4ksJ7bTTy4='
WHERE
key_id = 'a2d02a6d664a78c49edaf52f4e66346afbe98f42170ca0e73a7116903b2e7f98'
AND (
token = 'oHROK+tZX7AyFQSZ8iUGeO0ZmWonAqEPB4ksJ7bTTy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)