UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7lOKLldEOtvKozFLTSsqLFVlzZ5La4FreZY4RjM+PHI='
WHERE
key_id = '2ed6bcd7d1589d89172d8860f7bceb1bd78abea0cd694ed6ed265bcc185dd3bf'
AND (
token = '7lOKLldEOtvKozFLTSsqLFVlzZ5La4FreZY4RjM+PHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)