UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fyxp4PMGqsI6Nxef3KejgWN/sl+/NNVOEAYzfWcbLrI=' 
WHERE 
  key_id = '24ea12ce59f73bbd9a44c0b4ef8b8d8664abcd543f82480992fd7ef63a6ebfb8' 
  AND (
    token = 'fyxp4PMGqsI6Nxef3KejgWN/sl+/NNVOEAYzfWcbLrI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020