UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqIhYagln4y1W5IByRrF5NF2Mk/Z7cxolxfJboCHGZM='
WHERE
key_id = '1efe416f3043e7c22717d0624d2b2174e4b889790cd57457d77cac75cf27e271'
AND (
token = 'zqIhYagln4y1W5IByRrF5NF2Mk/Z7cxolxfJboCHGZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)