UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4c1/LtoCjtEmyAnWHoxh1bHuSAxzAfo6fk93CcqWeGI=' 
WHERE 
  key_id = '52540a10ab79d03c20fd35cda4b90a79360c5859fd322275a3df6ee243484aeb' 
  AND (
    token = '4c1/LtoCjtEmyAnWHoxh1bHuSAxzAfo6fk93CcqWeGI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023