UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Wyq/0XmFmqHeYDHdvsM3eyetSxNRsZYEq8EcJPQKMVM=' 
WHERE 
  key_id = 'f3148cc77acbc73bcf6e7e38d4f4f3f2f2545040bb837e860c690f95b436f868' 
  AND (
    token = 'Wyq/0XmFmqHeYDHdvsM3eyetSxNRsZYEq8EcJPQKMVM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028