UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0J4UFrX3cx7Ec6rotEdOxD/OmeJsu5Dv9fy5PzciBgY=' 
WHERE 
  key_id = 'a9e67330d0b41d1a97bbc1de6cfac6856a64cd69b65b052dd1c3dc831ca60795' 
  AND (
    token = '0J4UFrX3cx7Ec6rotEdOxD/OmeJsu5Dv9fy5PzciBgY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048