UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2ic3MSgsneeOO3jaRRTQ4KgrZcE+z5KzehA61wX86Jk=' 
WHERE 
  key_id = 'e1cb0ec53dfc3fc538cbaabdbfbb9b4587af5e765f59b184cff2c6b8614042cf' 
  AND (
    token = '2ic3MSgsneeOO3jaRRTQ4KgrZcE+z5KzehA61wX86Jk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026