UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkbxgC9ze7lqnNctVB3OWGw8juHe1+5EhiT1va5jDvI='
WHERE
key_id = '931a3b2c57f81dfbd74c19552508be000cc6c618b4f3026faae59cced5ab913e'
AND (
token = 'zkbxgC9ze7lqnNctVB3OWGw8juHe1+5EhiT1va5jDvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)