UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'poc7tb5TKc5+uxA5pxYXT8Ymk2ErzUGMto8VP0olwi8=' 
WHERE 
  key_id = 'b78a37d2f4d3880ee1989b18f03f30c4817fae26d4016c7ce6b0b2ea2629c174' 
  AND (
    token = 'poc7tb5TKc5+uxA5pxYXT8Ymk2ErzUGMto8VP0olwi8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030