UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nYw9CyGmWX8y/7lOz5iwFDdNhDnSQ5GSSSfW5lgcJAY='
WHERE
key_id = '7b9a2c1983875d42d4b91c3561f2fa32241877d1c582d54afcde3afa4a04b3dc'
AND (
token = 'nYw9CyGmWX8y/7lOz5iwFDdNhDnSQ5GSSSfW5lgcJAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)