UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZT9XxbXquz4Vzp5Las08S4wfx9Pp5Fnt8tZ1sVH756I=' 
WHERE 
  key_id = 'a02672e5a8cd5c93120f4188c1f71842243e54e94b6be2e6411da2502b84d8cb' 
  AND (
    token = 'ZT9XxbXquz4Vzp5Las08S4wfx9Pp5Fnt8tZ1sVH756I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024