UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wjUwFhdWMi5kS3Gv/UereVK/HtqyXgx/qenUm2mzTSE=' 
WHERE 
  key_id = '3bf8e6034209cac19f741cbaed70ac2a79f3969ea098e03c150f4c5af41fd2c6' 
  AND (
    token = 'wjUwFhdWMi5kS3Gv/UereVK/HtqyXgx/qenUm2mzTSE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027