UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'W7waAO/J/neh+b1W4G8AsnoutfhBzV0lF5a5WQwXAAM=' 
WHERE 
  key_id = '7c9634f7996358c14c98b249df48e109e28e3f70176deb986b918096406db88b' 
  AND (
    token = 'W7waAO/J/neh+b1W4G8AsnoutfhBzV0lF5a5WQwXAAM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029