UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oL5B8Okd8Zpa+depZHePDRg+L3wUsL24Mv09qS/ikJY=' 
WHERE 
  key_id = '76afacc609bfbb3516f51bd71b82eee20a1c143a5e42a16b9e4cf82638f04285' 
  AND (
    token = 'oL5B8Okd8Zpa+depZHePDRg+L3wUsL24Mv09qS/ikJY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026