UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KiXmoRkbf9ndiH29D9t61L8fVwWwanz3rq9ciLFcxDQ='
WHERE
key_id = '31b3e681370f8c8b3ce9483552e89e8fa8f025cea5ecad63882fa74d7413094a'
AND (
token = 'KiXmoRkbf9ndiH29D9t61L8fVwWwanz3rq9ciLFcxDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)