UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvV9oa5mrS8YyFY2VCK4cLwDUKQjL7SKQSBluMDLg3I='
WHERE
key_id = 'cac4956adedd76955d747f063927cd8e50aae363f601bc389c5162c9cad8a173'
AND (
token = 'VvV9oa5mrS8YyFY2VCK4cLwDUKQjL7SKQSBluMDLg3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)