UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+R0TZjrxYweY3eyE0AnIrbraWi+UPcoc/y1wHv+En5I='
WHERE
key_id = '9cdd4dd646b608e8669a31c995c5da19535a0850452bfb77beb5e7eae3a742b4'
AND (
token = '+R0TZjrxYweY3eyE0AnIrbraWi+UPcoc/y1wHv+En5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)