UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fkr5rqUJwk3KlL983qK3ak5a+8a8qBuie4vW7tZ+Lxo=' 
WHERE 
  key_id = '095cdf3ad01c946d6646f8667566a9f320cb1cf82771ce7c931026b6fee121de' 
  AND (
    token = 'fkr5rqUJwk3KlL983qK3ak5a+8a8qBuie4vW7tZ+Lxo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021