UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/5UM6mCSE7Cub0fCvGbZMlsK4Z2NLfqja4V6e61iczY=' 
WHERE 
  key_id = 'b9edfa7f61a74b52a5ee1d0cf76bda4797e9e2a4ccccc8a3bf41b22365ad1669' 
  AND (
    token = '/5UM6mCSE7Cub0fCvGbZMlsK4Z2NLfqja4V6e61iczY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023