UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ciLuvvaUMOQHTO6kEZGi6TKXfFl0uvz/CR1nBwY9qW8=' 
WHERE 
  key_id = '2c9845ea260cf162c96b9e0f9ab0e9efbc297018d1e59a5490e4eb49ecdc5836' 
  AND (
    token = 'ciLuvvaUMOQHTO6kEZGi6TKXfFl0uvz/CR1nBwY9qW8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022