UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pt/bWZcP8QpKV4LBVn8vqJyebExavp69fgdQ9BbMZIE=' 
WHERE 
  key_id = 'f164a88c4bb441970fdeb28ed3896591177ac21027541d05912f1120fc85a31e' 
  AND (
    token = 'pt/bWZcP8QpKV4LBVn8vqJyebExavp69fgdQ9BbMZIE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045