UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'I4Hlxz4/ORzNQkRpjyFr8IOk6/gjAu1Nlx5zTSo9aKA=' 
WHERE 
  key_id = '3be149234c7c0f649ca895a9da048580e4785c46b5abbd651a2a3e4b95c5fb61' 
  AND (
    token = 'I4Hlxz4/ORzNQkRpjyFr8IOk6/gjAu1Nlx5zTSo9aKA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038