UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R30oTOVHF4JWAPCpr00itm1C/4jv1GiKvHZoA9Ok9Aw='
WHERE
key_id = '9d7ec7ef7d4f385ffcd79a822365589f343bb8e816919b02927cce00b792f5ae'
AND (
token = 'R30oTOVHF4JWAPCpr00itm1C/4jv1GiKvHZoA9Ok9Aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)