UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P2I5OC6Gkjzstk2sKuV8v/cnPNRr8Dbm2+7HL8rIjkA='
WHERE
key_id = '162b19236b609fa8fa3a70a862f66e3cb9df5848d0a4eae0f4a0993e5fcaaee9'
AND (
token = 'P2I5OC6Gkjzstk2sKuV8v/cnPNRr8Dbm2+7HL8rIjkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)