UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ciyN3MX09AczW3fOpaGCtTtsE55Nc85BHyQsYjWsyJg='
WHERE
key_id = 'd213c746da636b3cfa1c1da882afa8cb3ea9d18cfcf71308275f91ee79049156'
AND (
token = 'ciyN3MX09AczW3fOpaGCtTtsE55Nc85BHyQsYjWsyJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)