UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 't4LY5hmpE1/nLR5PyYML3HNAC9Lh67qHWd5g8gVM9Q4=' 
WHERE 
  key_id = '196754a7cd62be0e43410ff320d236d19312ac881738a01db61dc008e56bb1ed' 
  AND (
    token = 't4LY5hmpE1/nLR5PyYML3HNAC9Lh67qHWd5g8gVM9Q4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033