UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z9C6rT/t7bWe6+3BEW/LYHoueS+fnAJv/SMzvSqy3QI=' 
WHERE 
  key_id = '0078c80c90af50f55e8fb68d0e2fe238ac15b02b28c60555f2476df4e77054d8' 
  AND (
    token = 'Z9C6rT/t7bWe6+3BEW/LYHoueS+fnAJv/SMzvSqy3QI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033