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