UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7floGu3Q72Zk1e1UEFBzvoPelL/q6XvUac9pVK23No8=' 
WHERE 
  key_id = '5a93bcc02d851261aa1c55b02baef331c60693147e61bd25e1acaee18851007b' 
  AND (
    token = '7floGu3Q72Zk1e1UEFBzvoPelL/q6XvUac9pVK23No8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023