UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CiXjJ4VwyKQ2Mb/XG9z+cxMbZC6syWhMkcjeFQpzxWQ='
WHERE
key_id = '5de0706e6324fb41d7c1757f0af29dc0a6214e55ae912bfc4d2b98163372c1fc'
AND (
token = 'CiXjJ4VwyKQ2Mb/XG9z+cxMbZC6syWhMkcjeFQpzxWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)